Automations

Data Manipulation Commands

  • Version: 1.7.0
  • Official Verified

OpenBots Command group containing data manipulation commands (Data, DataTable, Dictionary, List, RegEx).

OpenBots.Commands.DataManipulation \ Lookup Data Table Command

Command: Lookup Data Table Command

This command searches for a value inside a DataTable and returns the DataRow containing the cell. If the target column is set, it also returns the value of the cell from the specified DataRow.

Parameters

DataTable

Enter an existing DataTable to lookup from.

Required

Lookup Value

Enter the value to search for in the specified DataTable.

Required

Search Option (Lookup Column)

Select whether the Lookup Column should be found by column index or column name.

Required

Search Value (Lookup Column)

Enter a valid DataColumn index or column name.

Required

Search Option (Target Column)

Select whether the Target Column should be found by column index or column name.

Required

Search Value (Target Column)

Enter a valid DataColumn index or column name.

Output DataRow Variable

Create a new variable or select a variable from the list.

Output Cell Value Variable

Create a new variable or select a variable from the list.

Private (Optional)

Optional field to mark the command as private (data sensitive) in order to avoid its logging.

Error Handling

Optional field for how to handle errors encountered.

Required

Comment Field (Optional)

Optional field to enter a custom comment which could potentially describe this command or the need for this command.

Logo